Tabela StockItemQuantityIndex

Definicja tabeli StockItemQuantityIndex

Name

StockItemQuantityIndex

Code

StockItemQuantityIndex

Comment

 


Lista kolumn tabeli StockItemQuantityIndex

Name

Code

StockItemQuantityIndexID

StockItemQuantityIndexID

SeriesDataID

SeriesDataID

StockID

StockID

StockItemID

StockItemID

PackageID

PackageID

StockEntryDocumentItemID

StockEntryDocumentItemID

BloodDetailsID

BloodDetailsID

CostAccountID

CostAccountID

PersonID

PersonID

Price

Price

Quantity

Quantity

Value

Value

StockIndex

StockIndex

OwnerID

OwnerID

PatientID

PatientID

Comments

Comments


Kolumna StockItemQuantityIndexID tabeli StockItemQuantityIndex

Definicja kolumny StockItemQuantityIndexID tabeli StockItemQuantityIndex

Name

StockItemQuantityIndexID

Code

StockItemQuantityIndexID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SeriesDataID tabeli StockItemQuantityIndex

Definicja kolumny SeriesDataID tabeli StockItemQuantityIndex

Name

SeriesDataID

Code

SeriesDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockID tabeli StockItemQuantityIndex

Definicja kolumny StockID tabeli StockItemQuantityIndex

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockItemID tabeli StockItemQuantityIndex

Definicja kolumny StockItemID tabeli StockItemQuantityIndex

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu


Kolumna PackageID tabeli StockItemQuantityIndex

Definicja kolumny PackageID tabeli StockItemQuantityIndex

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockEntryDocumentItemID tabeli StockItemQuantityIndex

Definicja kolumny StockEntryDocumentItemID tabeli StockItemQuantityIndex

Name

StockEntryDocumentItemID

Code

StockEntryDocumentItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BloodDetailsID tabeli StockItemQuantityIndex

Definicja kolumny BloodDetailsID tabeli StockItemQuantityIndex

Name

BloodDetailsID

Code

BloodDetailsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli StockItemQuantityIndex

Definicja kolumny CostAccountID tabeli StockItemQuantityIndex

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli StockItemQuantityIndex

Definicja kolumny PersonID tabeli StockItemQuantityIndex

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Price tabeli StockItemQuantityIndex

Definicja kolumny Price tabeli StockItemQuantityIndex

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Quantity tabeli StockItemQuantityIndex

Definicja kolumny Quantity tabeli StockItemQuantityIndex

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc


Kolumna Value tabeli StockItemQuantityIndex

Definicja kolumny Value tabeli StockItemQuantityIndex

Name

Value

Code

Value

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna StockIndex tabeli StockItemQuantityIndex

Definicja kolumny StockIndex tabeli StockItemQuantityIndex

Name

StockIndex

Code

StockIndex

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli StockItemQuantityIndex

Definicja kolumny OwnerID tabeli StockItemQuantityIndex

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole sluzy do przechowywania informacji, iz danych stan magazynowy
(StockItemQuantityIndex) lub jego zmiana (StockItemQuantity) dotyczy leków
danego pacjenta. Leki przyniósl sam pacjent do szpitala.


Kolumna PatientID tabeli StockItemQuantityIndex

Definicja kolumny PatientID tabeli StockItemQuantityIndex

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole wskazuje z jakim pacjentem jest powiazany dane lek na magazynie.


Kolumna Comments tabeli StockItemQuantityIndex

Definicja kolumny Comments tabeli StockItemQuantityIndex

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz


Lista kluczy tabeli StockItemQuantityIndex

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockItemQuantityIndex

Definicja klucza Identifier_1 tabeli StockItemQuantityIndex

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment